﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CrossReferenceDataDataSet" targetNamespace="http://tempuri.org/CrossReferenceDataDataSet.xsd" xmlns:mstns="http://tempuri.org/CrossReferenceDataDataSet.xsd" xmlns="http://tempuri.org/CrossReferenceDataDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrossReferenceDataConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="CrossReferenceDataConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BizTalkCrossReferenceManager.Properties.Settings.GlobalReference.Default.CrossReferenceDataConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="xref_AppInstanceTableAdapter" GeneratorDataComponentClassName="xref_AppInstanceTableAdapter" Name="xref_AppInstance" UserDataComponentName="xref_AppInstanceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.xref_AppInstance" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[xref_AppInstance] WHERE (([appInstanceID] = @Original_appInstanceID) AND ([appInstance] = @Original_appInstance) AND ([appTypeID] = @Original_appTypeID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_appInstance" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appInstance" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[xref_AppInstance] ([appInstance], [appTypeID]) VALUES (@appInstance, @appTypeID);
SELECT appInstanceID, appInstance, appTypeID FROM xref_AppInstance WHERE (appInstanceID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@appInstance" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appInstance" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@appTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT appInstanceID, appInstance, appTypeID FROM dbo.xref_AppInstance</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[xref_AppInstance] SET [appInstance] = @appInstance, [appTypeID] = @appTypeID WHERE (([appInstanceID] = @Original_appInstanceID) AND ([appInstance] = @Original_appInstance) AND ([appTypeID] = @Original_appTypeID));
SELECT appInstanceID, appInstance, appTypeID FROM xref_AppInstance WHERE (appInstanceID = @appInstanceID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@appInstance" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appInstance" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@appTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_appInstance" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appInstance" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="appInstanceID" ColumnName="appInstanceID" DataSourceName="CrossReferenceData.dbo.xref_AppInstance" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="appInstanceID" DataSetColumn="appInstanceID" />
              <Mapping SourceColumn="appInstance" DataSetColumn="appInstance" />
              <Mapping SourceColumn="appTypeID" DataSetColumn="appTypeID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="xref_AppTypeTableAdapter" GeneratorDataComponentClassName="xref_AppTypeTableAdapter" Name="xref_AppType" UserDataComponentName="xref_AppTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.xref_AppType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[xref_AppType] WHERE (([appTypeID] = @Original_appTypeID) AND ([appType] = @Original_appType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_appType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[xref_AppType] ([appType]) VALUES (@appType);
SELECT appTypeID, appType FROM xref_AppType WHERE (appTypeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@appType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT appTypeID, appType FROM dbo.xref_AppType</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[xref_AppType] SET [appType] = @appType WHERE (([appTypeID] = @Original_appTypeID) AND ([appType] = @Original_appType));
SELECT appTypeID, appType FROM xref_AppType WHERE (appTypeID = @appTypeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@appType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_appType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="appTypeID" ColumnName="appTypeID" DataSourceName="CrossReferenceData.dbo.xref_AppType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@appTypeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="appTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="appTypeID" DataSetColumn="appTypeID" />
              <Mapping SourceColumn="appType" DataSetColumn="appType" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="xref_IDXRefTableAdapter" GeneratorDataComponentClassName="xref_IDXRefTableAdapter" Name="xref_IDXRef" UserDataComponentName="xref_IDXRefTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.xref_IDXRef" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[xref_IDXRef] WHERE (([idXRefID] = @Original_idXRefID) AND ([idXRef] = @Original_idXRef))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_idXRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="idXRef" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[xref_IDXRef] ([idXRef]) VALUES (@idXRef);
SELECT idXRefID, idXRef FROM xref_IDXRef WHERE (idXRefID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@idXRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="idXRef" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT idXRefID, idXRef FROM dbo.xref_IDXRef</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[xref_IDXRef] SET [idXRef] = @idXRef WHERE (([idXRefID] = @Original_idXRefID) AND ([idXRef] = @Original_idXRef));
SELECT idXRefID, idXRef FROM xref_IDXRef WHERE (idXRefID = @idXRefID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@idXRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="idXRef" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_idXRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="idXRef" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="idXRefID" ColumnName="idXRefID" DataSourceName="CrossReferenceData.dbo.xref_IDXRef" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idXRefID" DataSetColumn="idXRefID" />
              <Mapping SourceColumn="idXRef" DataSetColumn="idXRef" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="xref_IDXRefCommonValuesTableAdapter" GeneratorDataComponentClassName="xref_IDXRefCommonValuesTableAdapter" Name="xref_IDXRefCommonValues" UserDataComponentName="xref_IDXRefCommonValuesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.xref_IDXRefCommonValues" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[xref_IDXRefCommonValues] WHERE (([commonID] = @Original_commonID) AND ([idXRefID] = @Original_idXRefID) AND ([commonIDDescription] = @Original_commonIDDescription))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_commonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="commonID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_commonIDDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="commonIDDescription" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[xref_IDXRefCommonValues] ([idXRefID], [commonIDDescription]) VALUES (@idXRefID, @commonIDDescription);
SELECT commonID, idXRefID, commonIDDescription FROM xref_IDXRefCommonValues WHERE (commonID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@commonIDDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="commonIDDescription" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT commonID, idXRefID, commonIDDescription FROM dbo.xref_IDXRefCommonValues</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[xref_IDXRefCommonValues] SET [idXRefID] = @idXRefID, [commonIDDescription] = @commonIDDescription WHERE (([commonID] = @Original_commonID) AND ([idXRefID] = @Original_idXRefID) AND ([commonIDDescription] = @Original_commonIDDescription));
SELECT commonID, idXRefID, commonIDDescription FROM xref_IDXRefCommonValues WHERE (commonID = @commonID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@commonIDDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="commonIDDescription" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_commonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="commonID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_commonIDDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="commonIDDescription" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="commonID" ColumnName="commonID" DataSourceName="CrossReferenceData.dbo.xref_IDXRefCommonValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@commonID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="commonID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="commonID" DataSetColumn="commonID" />
              <Mapping SourceColumn="idXRefID" DataSetColumn="idXRefID" />
              <Mapping SourceColumn="commonIDDescription" DataSetColumn="commonIDDescription" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.xref_IDXRefCommonValues" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByXRefTypeId" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByXRefTypeId" GeneratorSourceName="FillByXRefTypeId" GetMethodModifier="Public" GetMethodName="GetDataByXRefTypeId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByXRefTypeId" UserSourceName="FillByXRefTypeId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     commonID, idXRefID, commonIDDescription
FROM         xref_IDXRefCommonValues
WHERE     (idXRefID = @idXRefId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="idXRefId" ColumnName="idXRefID" DataSourceName="CrossReferenceData.dbo.xref_IDXRefCommonValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idXRefId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="xref_IDXRefDataTableAdapter" GeneratorDataComponentClassName="xref_IDXRefDataTableAdapter" Name="xref_IDXRefData" UserDataComponentName="xref_IDXRefDataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.xref_IDXRefData" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[xref_IDXRefData] WHERE (([idXRefID] = @Original_idXRefID) AND ([appInstanceID] = @Original_appInstanceID) AND ([appID] = @Original_appID) AND ([commonID] = @Original_commonID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_appID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_commonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="commonID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[xref_IDXRefData] ([idXRefID], [appInstanceID], [appID], [commonID]) VALUES (@idXRefID, @appInstanceID, @appID, @commonID);
SELECT idXRefID, appInstanceID, appID, commonID FROM xref_IDXRefData WHERE (appInstanceID = @appInstanceID) AND (commonID = @commonID) AND (idXRefID = @idXRefID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@appID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@commonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="commonID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT idXRefID, appInstanceID, appID, commonID FROM dbo.xref_IDXRefData</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[xref_IDXRefData] SET [idXRefID] = @idXRefID, [appInstanceID] = @appInstanceID, [appID] = @appID, [commonID] = @commonID WHERE (([idXRefID] = @Original_idXRefID) AND ([appInstanceID] = @Original_appInstanceID) AND ([appID] = @Original_appID) AND ([commonID] = @Original_commonID));
SELECT idXRefID, appInstanceID, appID, commonID FROM xref_IDXRefData WHERE (appInstanceID = @appInstanceID) AND (commonID = @commonID) AND (idXRefID = @idXRefID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@appID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@commonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="commonID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_appID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="appID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_commonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="commonID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idXRefID" DataSetColumn="idXRefID" />
              <Mapping SourceColumn="appInstanceID" DataSetColumn="appInstanceID" />
              <Mapping SourceColumn="appID" DataSetColumn="appID" />
              <Mapping SourceColumn="commonID" DataSetColumn="commonID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.xref_IDXRefData" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByAppInstanceAndXRefType" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByAppInstanceAndXRefType" GeneratorSourceName="FillByAppInstanceAndXRefType" GetMethodModifier="Public" GetMethodName="GetDataByAppInstanceAndXRefType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByAppInstanceAndXRefType" UserSourceName="FillByAppInstanceAndXRefType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     idXRefID, appInstanceID, appID, commonID
FROM         xref_IDXRefData
WHERE     (idXRefID = @xRefId) AND (appInstanceID = @appInstanceId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="xRefId" ColumnName="idXRefID" DataSourceName="CrossReferenceData.dbo.xref_IDXRefData" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@xRefId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="appInstanceId" ColumnName="appInstanceID" DataSourceName="CrossReferenceData.dbo.xref_IDXRefData" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@appInstanceId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ApplicationXRefIDsTableAdapter" GeneratorDataComponentClassName="ApplicationXRefIDsTableAdapter" Name="ApplicationXRefIDs" UserDataComponentName="ApplicationXRefIDsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.ApplicationXRefIDs" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT appID, appInstance, idXRef, commonIDDescription FROM dbo.ApplicationXRefIDs</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="appID" DataSetColumn="appID" />
              <Mapping SourceColumn="appInstance" DataSetColumn="appInstance" />
              <Mapping SourceColumn="idXRef" DataSetColumn="idXRef" />
              <Mapping SourceColumn="commonIDDescription" DataSetColumn="commonIDDescription" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AppInstanceDetailsTableAdapter" GeneratorDataComponentClassName="AppInstanceDetailsTableAdapter" Name="AppInstanceDetails" UserDataComponentName="AppInstanceDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     xref_AppType.appTypeID, xref_AppType.appType, xref_AppInstance.appInstanceID, xref_AppInstance.appInstance
FROM         xref_AppType INNER JOIN
                      xref_AppInstance ON xref_AppType.appTypeID = xref_AppInstance.appTypeID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="appTypeID" DataSetColumn="appTypeID" />
              <Mapping SourceColumn="appType" DataSetColumn="appType" />
              <Mapping SourceColumn="appInstanceID" DataSetColumn="appInstanceID" />
              <Mapping SourceColumn="appInstance" DataSetColumn="appInstance" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="xref_AppInstanceViewTableAdapter" GeneratorDataComponentClassName="xref_AppInstanceViewTableAdapter" Name="xref_AppInstanceView" UserDataComponentName="xref_AppInstanceViewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     xref_AppInstance.appInstance, xref_AppType.appType
FROM         xref_AppInstance INNER JOIN
                      xref_AppType ON xref_AppInstance.appTypeID = xref_AppType.appTypeID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="appInstance" DataSetColumn="appInstance" />
              <Mapping SourceColumn="appType" DataSetColumn="appType" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="xref_IDXRefDataViewTableAdapter" GeneratorDataComponentClassName="xref_IDXRefDataViewTableAdapter" Name="xref_IDXRefDataView" UserDataComponentName="xref_IDXRefDataViewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     xref_IDXRef.idXRefID, xref_IDXRef.idXRef, xref_IDXRefCommonValues.commonID, xref_IDXRefCommonValues.commonIDDescription, 
                      xref_AppInstance.appInstanceID, xref_AppInstance.appInstance, xref_IDXRefData.appID
FROM         xref_IDXRefData INNER JOIN
                      xref_IDXRefCommonValues ON xref_IDXRefData.commonID = xref_IDXRefCommonValues.commonID INNER JOIN
                      xref_IDXRef ON xref_IDXRefData.idXRefID = xref_IDXRef.idXRefID AND xref_IDXRefCommonValues.idXRefID = xref_IDXRef.idXRefID INNER JOIN
                      xref_AppInstance ON xref_IDXRefData.appInstanceID = xref_AppInstance.appInstanceID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idXRefID" DataSetColumn="idXRefID" />
              <Mapping SourceColumn="idXRef" DataSetColumn="idXRef" />
              <Mapping SourceColumn="commonID" DataSetColumn="commonID" />
              <Mapping SourceColumn="commonIDDescription" DataSetColumn="commonIDDescription" />
              <Mapping SourceColumn="appInstanceID" DataSetColumn="appInstanceID" />
              <Mapping SourceColumn="appInstance" DataSetColumn="appInstance" />
              <Mapping SourceColumn="appID" DataSetColumn="appID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByAppInstanceIdAndXRefId" GetMethodModifier="Public" GetMethodName="GetDataByAppInstanceIdAndXRefId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByAppInstanceIdAndXRefId" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     xref_IDXRef.idXRefID, xref_IDXRef.idXRef, xref_IDXRefCommonValues.commonID, xref_IDXRefCommonValues.commonIDDescription, 
                      xref_AppInstance.appInstanceID, xref_AppInstance.appInstance, xref_IDXRefData.appID
FROM         xref_IDXRefData INNER JOIN
                      xref_IDXRefCommonValues ON xref_IDXRefData.commonID = xref_IDXRefCommonValues.commonID INNER JOIN
                      xref_IDXRef ON xref_IDXRefData.idXRefID = xref_IDXRef.idXRefID AND xref_IDXRefCommonValues.idXRefID = xref_IDXRef.idXRefID INNER JOIN
                      xref_AppInstance ON xref_IDXRefData.appInstanceID = xref_AppInstance.appInstanceID
WHERE     (xref_IDXRef.idXRefID = @idXRefID) AND (xref_AppInstance.appInstanceID = @appInstanceID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="idXRefID" ColumnName="idXRefID" DataSourceName="TestCrossReferenceData.dbo.xref_IDXRef" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idXRefID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idXRefID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="appInstanceID" ColumnName="appInstanceID" DataSourceName="TestCrossReferenceData.dbo.xref_AppInstance" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@appInstanceID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="appInstanceID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.GetXRefIdCrossTab" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="GetXRefIdCrossTab" MethodsParameterType="CLR" Modifier="Public" Name="GetXRefIdCrossTab" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="GetXRefIdCrossTab">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                <CommandText>dbo.GetXRefIdCrossTab</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@idXRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="CrossReferenceDataConnectionString (Settings)" DbObjectName="CrossReferenceData.dbo.UpdateApplicationXRefId" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="UpdateApplicationXRefId" MethodsParameterType="CLR" Modifier="Public" Name="UpdateApplicationXRefId" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="UpdateApplicationXRefId">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                <CommandText>dbo.UpdateApplicationXRefId</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApplicationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IdXRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CommonIdDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApplicationId" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CrossReferenceDataDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="CrossReferenceDataDataSet" msprop:Generator_DataSetName="CrossReferenceDataDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="xref_AppInstance" msprop:Generator_UserTableName="xref_AppInstance" msprop:Generator_RowDeletedName="xref_AppInstanceRowDeleted" msprop:Generator_RowChangedName="xref_AppInstanceRowChanged" msprop:Generator_RowClassName="xref_AppInstanceRow" msprop:Generator_RowChangingName="xref_AppInstanceRowChanging" msprop:Generator_RowEvArgName="xref_AppInstanceRowChangeEvent" msprop:Generator_RowEvHandlerName="xref_AppInstanceRowChangeEventHandler" msprop:Generator_TableClassName="xref_AppInstanceDataTable" msprop:Generator_TableVarName="tablexref_AppInstance" msprop:Generator_RowDeletingName="xref_AppInstanceRowDeleting" msprop:Generator_TablePropName="xref_AppInstance">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="appInstanceID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_UserColumnName="appInstanceID" msprop:Generator_ColumnVarNameInTable="columnappInstanceID" msprop:Generator_ColumnPropNameInRow="appInstanceID" msprop:Generator_ColumnPropNameInTable="appInstanceIDColumn" type="xs:int" />
              <xs:element name="appInstance" msprop:Generator_UserColumnName="appInstance" msprop:Generator_ColumnVarNameInTable="columnappInstance" msprop:Generator_ColumnPropNameInRow="appInstance" msprop:Generator_ColumnPropNameInTable="appInstanceColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="appTypeID" msprop:Generator_UserColumnName="appTypeID" msprop:Generator_ColumnVarNameInTable="columnappTypeID" msprop:Generator_ColumnPropNameInRow="appTypeID" msprop:Generator_ColumnPropNameInTable="appTypeIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="xref_AppType" msprop:Generator_UserTableName="xref_AppType" msprop:Generator_RowDeletedName="xref_AppTypeRowDeleted" msprop:Generator_RowChangedName="xref_AppTypeRowChanged" msprop:Generator_RowClassName="xref_AppTypeRow" msprop:Generator_RowChangingName="xref_AppTypeRowChanging" msprop:Generator_RowEvArgName="xref_AppTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="xref_AppTypeRowChangeEventHandler" msprop:Generator_TableClassName="xref_AppTypeDataTable" msprop:Generator_TableVarName="tablexref_AppType" msprop:Generator_RowDeletingName="xref_AppTypeRowDeleting" msprop:Generator_TablePropName="xref_AppType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="appTypeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_UserColumnName="appTypeID" msprop:Generator_ColumnVarNameInTable="columnappTypeID" msprop:Generator_ColumnPropNameInRow="appTypeID" msprop:Generator_ColumnPropNameInTable="appTypeIDColumn" type="xs:int" />
              <xs:element name="appType" msprop:Generator_UserColumnName="appType" msprop:Generator_ColumnVarNameInTable="columnappType" msprop:Generator_ColumnPropNameInRow="appType" msprop:Generator_ColumnPropNameInTable="appTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="xref_IDXRef" msprop:Generator_UserTableName="xref_IDXRef" msprop:Generator_RowDeletedName="xref_IDXRefRowDeleted" msprop:Generator_RowChangedName="xref_IDXRefRowChanged" msprop:Generator_RowClassName="xref_IDXRefRow" msprop:Generator_RowChangingName="xref_IDXRefRowChanging" msprop:Generator_RowEvArgName="xref_IDXRefRowChangeEvent" msprop:Generator_RowEvHandlerName="xref_IDXRefRowChangeEventHandler" msprop:Generator_TableClassName="xref_IDXRefDataTable" msprop:Generator_TableVarName="tablexref_IDXRef" msprop:Generator_RowDeletingName="xref_IDXRefRowDeleting" msprop:Generator_TablePropName="xref_IDXRef">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idXRefID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_UserColumnName="idXRefID" msprop:Generator_ColumnVarNameInTable="columnidXRefID" msprop:Generator_ColumnPropNameInRow="idXRefID" msprop:Generator_ColumnPropNameInTable="idXRefIDColumn" type="xs:int" />
              <xs:element name="idXRef" msprop:Generator_UserColumnName="idXRef" msprop:Generator_ColumnVarNameInTable="columnidXRef" msprop:Generator_ColumnPropNameInRow="idXRef" msprop:Generator_ColumnPropNameInTable="idXRefColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="xref_IDXRefCommonValues" msprop:Generator_UserTableName="xref_IDXRefCommonValues" msprop:Generator_RowDeletedName="xref_IDXRefCommonValuesRowDeleted" msprop:Generator_RowChangedName="xref_IDXRefCommonValuesRowChanged" msprop:Generator_RowClassName="xref_IDXRefCommonValuesRow" msprop:Generator_RowChangingName="xref_IDXRefCommonValuesRowChanging" msprop:Generator_RowEvArgName="xref_IDXRefCommonValuesRowChangeEvent" msprop:Generator_RowEvHandlerName="xref_IDXRefCommonValuesRowChangeEventHandler" msprop:Generator_TableClassName="xref_IDXRefCommonValuesDataTable" msprop:Generator_TableVarName="tablexref_IDXRefCommonValues" msprop:Generator_RowDeletingName="xref_IDXRefCommonValuesRowDeleting" msprop:Generator_TablePropName="xref_IDXRefCommonValues">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="commonID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_UserColumnName="commonID" msprop:Generator_ColumnVarNameInTable="columncommonID" msprop:Generator_ColumnPropNameInRow="commonID" msprop:Generator_ColumnPropNameInTable="commonIDColumn" type="xs:int" />
              <xs:element name="idXRefID" msprop:Generator_UserColumnName="idXRefID" msprop:Generator_ColumnVarNameInTable="columnidXRefID" msprop:Generator_ColumnPropNameInRow="idXRefID" msprop:Generator_ColumnPropNameInTable="idXRefIDColumn" type="xs:int" />
              <xs:element name="commonIDDescription" msprop:Generator_UserColumnName="commonIDDescription" msprop:Generator_ColumnVarNameInTable="columncommonIDDescription" msprop:Generator_ColumnPropNameInRow="commonIDDescription" msprop:Generator_ColumnPropNameInTable="commonIDDescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="xref_IDXRefData" msprop:Generator_UserTableName="xref_IDXRefData" msprop:Generator_RowDeletedName="xref_IDXRefDataRowDeleted" msprop:Generator_RowChangedName="xref_IDXRefDataRowChanged" msprop:Generator_RowClassName="xref_IDXRefDataRow" msprop:Generator_RowChangingName="xref_IDXRefDataRowChanging" msprop:Generator_RowEvArgName="xref_IDXRefDataRowChangeEvent" msprop:Generator_RowEvHandlerName="xref_IDXRefDataRowChangeEventHandler" msprop:Generator_TableClassName="xref_IDXRefDataDataTable" msprop:Generator_TableVarName="tablexref_IDXRefData" msprop:Generator_RowDeletingName="xref_IDXRefDataRowDeleting" msprop:Generator_TablePropName="xref_IDXRefData">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idXRefID" msprop:Generator_UserColumnName="idXRefID" msprop:Generator_ColumnVarNameInTable="columnidXRefID" msprop:Generator_ColumnPropNameInRow="idXRefID" msprop:Generator_ColumnPropNameInTable="idXRefIDColumn" type="xs:int" />
              <xs:element name="appInstanceID" msprop:Generator_UserColumnName="appInstanceID" msprop:Generator_ColumnVarNameInTable="columnappInstanceID" msprop:Generator_ColumnPropNameInRow="appInstanceID" msprop:Generator_ColumnPropNameInTable="appInstanceIDColumn" type="xs:int" />
              <xs:element name="appID" msprop:Generator_UserColumnName="appID" msprop:Generator_ColumnVarNameInTable="columnappID" msprop:Generator_ColumnPropNameInRow="appID" msprop:Generator_ColumnPropNameInTable="appIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="commonID" msprop:Generator_UserColumnName="commonID" msprop:Generator_ColumnVarNameInTable="columncommonID" msprop:Generator_ColumnPropNameInRow="commonID" msprop:Generator_ColumnPropNameInTable="commonIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ApplicationXRefIDs" msprop:Generator_UserTableName="ApplicationXRefIDs" msprop:Generator_RowDeletedName="ApplicationXRefIDsRowDeleted" msprop:Generator_RowChangedName="ApplicationXRefIDsRowChanged" msprop:Generator_RowClassName="ApplicationXRefIDsRow" msprop:Generator_RowChangingName="ApplicationXRefIDsRowChanging" msprop:Generator_RowEvArgName="ApplicationXRefIDsRowChangeEvent" msprop:Generator_RowEvHandlerName="ApplicationXRefIDsRowChangeEventHandler" msprop:Generator_TableClassName="ApplicationXRefIDsDataTable" msprop:Generator_TableVarName="tableApplicationXRefIDs" msprop:Generator_RowDeletingName="ApplicationXRefIDsRowDeleting" msprop:Generator_TablePropName="ApplicationXRefIDs">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="appID" msprop:Generator_UserColumnName="appID" msprop:Generator_ColumnVarNameInTable="columnappID" msprop:Generator_ColumnPropNameInRow="appID" msprop:Generator_ColumnPropNameInTable="appIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="appInstance" msprop:Generator_UserColumnName="appInstance" msprop:Generator_ColumnVarNameInTable="columnappInstance" msprop:Generator_ColumnPropNameInRow="appInstance" msprop:Generator_ColumnPropNameInTable="appInstanceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idXRef" msprop:Generator_UserColumnName="idXRef" msprop:Generator_ColumnVarNameInTable="columnidXRef" msprop:Generator_ColumnPropNameInRow="idXRef" msprop:Generator_ColumnPropNameInTable="idXRefColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="commonIDDescription" msprop:Generator_UserColumnName="commonIDDescription" msprop:Generator_ColumnVarNameInTable="columncommonIDDescription" msprop:Generator_ColumnPropNameInRow="commonIDDescription" msprop:Generator_ColumnPropNameInTable="commonIDDescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AppInstanceDetails" msprop:Generator_UserTableName="AppInstanceDetails" msprop:Generator_RowDeletedName="AppInstanceDetailsRowDeleted" msprop:Generator_RowChangedName="AppInstanceDetailsRowChanged" msprop:Generator_RowClassName="AppInstanceDetailsRow" msprop:Generator_RowChangingName="AppInstanceDetailsRowChanging" msprop:Generator_RowEvArgName="AppInstanceDetailsRowChangeEvent" msprop:Generator_RowEvHandlerName="AppInstanceDetailsRowChangeEventHandler" msprop:Generator_TableClassName="AppInstanceDetailsDataTable" msprop:Generator_TableVarName="tableAppInstanceDetails" msprop:Generator_RowDeletingName="AppInstanceDetailsRowDeleting" msprop:Generator_TablePropName="AppInstanceDetails">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="appTypeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="appTypeID" msprop:Generator_ColumnPropNameInRow="appTypeID" msprop:Generator_ColumnVarNameInTable="columnappTypeID" msprop:Generator_ColumnPropNameInTable="appTypeIDColumn" type="xs:int" />
              <xs:element name="appType" msprop:Generator_UserColumnName="appType" msprop:Generator_ColumnPropNameInRow="appType" msprop:Generator_ColumnVarNameInTable="columnappType" msprop:Generator_ColumnPropNameInTable="appTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="appInstanceID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="appInstanceID" msprop:Generator_ColumnPropNameInRow="appInstanceID" msprop:Generator_ColumnVarNameInTable="columnappInstanceID" msprop:Generator_ColumnPropNameInTable="appInstanceIDColumn" type="xs:int" />
              <xs:element name="appInstance" msprop:Generator_UserColumnName="appInstance" msprop:Generator_ColumnPropNameInRow="appInstance" msprop:Generator_ColumnVarNameInTable="columnappInstance" msprop:Generator_ColumnPropNameInTable="appInstanceColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="xref_AppInstanceView" msprop:Generator_UserTableName="xref_AppInstanceView" msprop:Generator_RowDeletedName="xref_AppInstanceViewRowDeleted" msprop:Generator_RowChangedName="xref_AppInstanceViewRowChanged" msprop:Generator_RowClassName="xref_AppInstanceViewRow" msprop:Generator_RowChangingName="xref_AppInstanceViewRowChanging" msprop:Generator_RowEvArgName="xref_AppInstanceViewRowChangeEvent" msprop:Generator_RowEvHandlerName="xref_AppInstanceViewRowChangeEventHandler" msprop:Generator_TableClassName="xref_AppInstanceViewDataTable" msprop:Generator_TableVarName="tablexref_AppInstanceView" msprop:Generator_RowDeletingName="xref_AppInstanceViewRowDeleting" msprop:Generator_TablePropName="xref_AppInstanceView">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="appInstance" msprop:Generator_UserColumnName="appInstance" msprop:Generator_ColumnPropNameInRow="appInstance" msprop:Generator_ColumnVarNameInTable="columnappInstance" msprop:Generator_ColumnPropNameInTable="appInstanceColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="appType" msprop:Generator_UserColumnName="appType" msprop:Generator_ColumnPropNameInRow="appType" msprop:Generator_ColumnVarNameInTable="columnappType" msprop:Generator_ColumnPropNameInTable="appTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="xref_IDXRefDataView" msprop:Generator_UserTableName="xref_IDXRefDataView" msprop:Generator_RowDeletedName="xref_IDXRefDataViewRowDeleted" msprop:Generator_TableClassName="xref_IDXRefDataViewDataTable" msprop:Generator_RowChangedName="xref_IDXRefDataViewRowChanged" msprop:Generator_RowClassName="xref_IDXRefDataViewRow" msprop:Generator_RowChangingName="xref_IDXRefDataViewRowChanging" msprop:Generator_RowEvArgName="xref_IDXRefDataViewRowChangeEvent" msprop:Generator_RowEvHandlerName="xref_IDXRefDataViewRowChangeEventHandler" msprop:Generator_TablePropName="xref_IDXRefDataView" msprop:Generator_TableVarName="tablexref_IDXRefDataView" msprop:Generator_RowDeletingName="xref_IDXRefDataViewRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idXRefID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="idXRefID" msprop:Generator_ColumnPropNameInRow="idXRefID" msprop:Generator_ColumnVarNameInTable="columnidXRefID" msprop:Generator_ColumnPropNameInTable="idXRefIDColumn" type="xs:int" />
              <xs:element name="idXRef" msprop:Generator_UserColumnName="idXRef" msprop:Generator_ColumnPropNameInRow="idXRef" msprop:Generator_ColumnVarNameInTable="columnidXRef" msprop:Generator_ColumnPropNameInTable="idXRefColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="commonID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="commonID" msprop:Generator_ColumnPropNameInRow="commonID" msprop:Generator_ColumnVarNameInTable="columncommonID" msprop:Generator_ColumnPropNameInTable="commonIDColumn" type="xs:int" />
              <xs:element name="commonIDDescription" msprop:Generator_UserColumnName="commonIDDescription" msprop:Generator_ColumnPropNameInRow="commonIDDescription" msprop:Generator_ColumnVarNameInTable="columncommonIDDescription" msprop:Generator_ColumnPropNameInTable="commonIDDescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="appInstanceID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="appInstanceID" msprop:Generator_ColumnPropNameInRow="appInstanceID" msprop:Generator_ColumnVarNameInTable="columnappInstanceID" msprop:Generator_ColumnPropNameInTable="appInstanceIDColumn" type="xs:int" />
              <xs:element name="appInstance" msprop:Generator_UserColumnName="appInstance" msprop:Generator_ColumnPropNameInRow="appInstance" msprop:Generator_ColumnVarNameInTable="columnappInstance" msprop:Generator_ColumnPropNameInTable="appInstanceColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="appID" msprop:Generator_UserColumnName="appID" msprop:Generator_ColumnPropNameInRow="appID" msprop:Generator_ColumnVarNameInTable="columnappID" msprop:Generator_ColumnPropNameInTable="appIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:xref_AppInstance" />
      <xs:field xpath="mstns:appInstanceID" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:xref_AppInstance" />
      <xs:field xpath="mstns:appInstance" />
    </xs:unique>
    <xs:unique name="xref_AppType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:xref_AppType" />
      <xs:field xpath="mstns:appTypeID" />
    </xs:unique>
    <xs:unique name="xref_AppType_Constraint2" msdata:ConstraintName="Constraint2">
      <xs:selector xpath=".//mstns:xref_AppType" />
      <xs:field xpath="mstns:appType" />
    </xs:unique>
    <xs:unique name="xref_IDXRef_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:xref_IDXRef" />
      <xs:field xpath="mstns:idXRefID" />
    </xs:unique>
    <xs:unique name="xref_IDXRef_Constraint2" msdata:ConstraintName="Constraint2">
      <xs:selector xpath=".//mstns:xref_IDXRef" />
      <xs:field xpath="mstns:idXRef" />
    </xs:unique>
    <xs:unique name="xref_IDXRefCommonValues_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:xref_IDXRefCommonValues" />
      <xs:field xpath="mstns:commonID" />
    </xs:unique>
    <xs:unique name="xref_IDXRefCommonValuesKey1">
      <xs:selector xpath=".//mstns:xref_IDXRefCommonValues" />
      <xs:field xpath="mstns:idXRefID" />
      <xs:field xpath="mstns:commonIDDescription" />
    </xs:unique>
    <xs:unique name="xref_IDXRefData_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:xref_IDXRefData" />
      <xs:field xpath="mstns:idXRefID" />
      <xs:field xpath="mstns:appInstanceID" />
      <xs:field xpath="mstns:commonID" />
    </xs:unique>
    <xs:unique name="AppInstanceDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AppInstanceDetails" />
      <xs:field xpath="mstns:appTypeID" />
      <xs:field xpath="mstns:appInstanceID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_xref_AppInstance_xref_AppType" msdata:parent="xref_AppType" msdata:child="xref_AppInstance" msdata:parentkey="appTypeID" msdata:childkey="appTypeID" msprop:Generator_UserRelationName="FK_xref_AppInstance_xref_AppType" msprop:Generator_RelationVarName="relationFK_xref_AppInstance_xref_AppType" msprop:Generator_UserChildTable="xref_AppInstance" msprop:Generator_UserParentTable="xref_AppType" msprop:Generator_ParentPropName="xref_AppTypeRow" msprop:Generator_ChildPropName="Getxref_AppInstanceRows" />
      <msdata:Relationship name="FK_xref_IDXRefCommonValues_xref_IDXRef" msdata:parent="xref_IDXRef" msdata:child="xref_IDXRefCommonValues" msdata:parentkey="idXRefID" msdata:childkey="idXRefID" msprop:Generator_UserRelationName="FK_xref_IDXRefCommonValues_xref_IDXRef" msprop:Generator_RelationVarName="relationFK_xref_IDXRefCommonValues_xref_IDXRef" msprop:Generator_UserChildTable="xref_IDXRefCommonValues" msprop:Generator_UserParentTable="xref_IDXRef" msprop:Generator_ParentPropName="xref_IDXRefRow" msprop:Generator_ChildPropName="Getxref_IDXRefCommonValuesRows" />
      <msdata:Relationship name="FK_xref_IDXRefData_xref_AppInstance" msdata:parent="xref_AppInstance" msdata:child="xref_IDXRefData" msdata:parentkey="appInstanceID" msdata:childkey="appInstanceID" msprop:Generator_UserRelationName="FK_xref_IDXRefData_xref_AppInstance" msprop:Generator_RelationVarName="relationFK_xref_IDXRefData_xref_AppInstance" msprop:Generator_UserChildTable="xref_IDXRefData" msprop:Generator_UserParentTable="xref_AppInstance" msprop:Generator_ParentPropName="xref_AppInstanceRow" msprop:Generator_ChildPropName="Getxref_IDXRefDataRows" />
      <msdata:Relationship name="FK_xref_IDXRefData_xref_IDXRef" msdata:parent="xref_IDXRef" msdata:child="xref_IDXRefData" msdata:parentkey="idXRefID" msdata:childkey="idXRefID" msprop:Generator_UserRelationName="FK_xref_IDXRefData_xref_IDXRef" msprop:Generator_RelationVarName="relationFK_xref_IDXRefData_xref_IDXRef" msprop:Generator_UserChildTable="xref_IDXRefData" msprop:Generator_UserParentTable="xref_IDXRef" msprop:Generator_ParentPropName="xref_IDXRefRow" msprop:Generator_ChildPropName="Getxref_IDXRefDataRows" />
      <msdata:Relationship name="FK_xref_IDXRefData_xref_IDXRefCommonValues" msdata:parent="xref_IDXRefCommonValues" msdata:child="xref_IDXRefData" msdata:parentkey="commonID" msdata:childkey="commonID" msprop:Generator_UserRelationName="FK_xref_IDXRefData_xref_IDXRefCommonValues" msprop:Generator_RelationVarName="relationFK_xref_IDXRefData_xref_IDXRefCommonValues" msprop:Generator_UserChildTable="xref_IDXRefData" msprop:Generator_UserParentTable="xref_IDXRefCommonValues" msprop:Generator_ParentPropName="xref_IDXRefCommonValuesRow" msprop:Generator_ChildPropName="Getxref_IDXRefDataRows" />
      <msdata:Relationship name="FK_xref_IDXRefData_xref_AppInstance1" msdata:parent="AppInstanceDetails" msdata:child="xref_IDXRefData" msdata:parentkey="appInstanceID" msdata:childkey="appInstanceID" msprop:Generator_UserRelationName="FK_xref_IDXRefData_xref_AppInstance1" msprop:Generator_RelationVarName="relationFK_xref_IDXRefData_xref_AppInstance1" msprop:Generator_UserChildTable="xref_IDXRefData" msprop:Generator_UserParentTable="AppInstanceDetails" msprop:Generator_ParentPropName="AppInstanceDetailsRow" msprop:Generator_ChildPropName="Getxref_IDXRefDataRows" />
      <msdata:Relationship name="FK_xref_AppInstance_xref_AppType1" msdata:parent="xref_AppType" msdata:child="AppInstanceDetails" msdata:parentkey="appTypeID" msdata:childkey="appTypeID" msprop:Generator_UserRelationName="FK_xref_AppInstance_xref_AppType1" msprop:Generator_RelationVarName="relationFK_xref_AppInstance_xref_AppType1" msprop:Generator_UserChildTable="AppInstanceDetails" msprop:Generator_UserParentTable="xref_AppType" msprop:Generator_ParentPropName="xref_AppTypeRow" msprop:Generator_ChildPropName="GetAppInstanceDetailsRows" />
      <msdata:Relationship name="FK_xref_IDXRefData_xref_AppInstance2" msdata:parent="xref_IDXRefDataView" msdata:child="xref_IDXRefData" msdata:parentkey="appInstanceID" msdata:childkey="appInstanceID" msprop:Generator_UserRelationName="FK_xref_IDXRefData_xref_AppInstance2" msprop:Generator_RelationVarName="relationFK_xref_IDXRefData_xref_AppInstance2" msprop:Generator_UserChildTable="xref_IDXRefData" msprop:Generator_UserParentTable="xref_IDXRefDataView" msprop:Generator_ParentPropName="xref_IDXRefDataViewRow" msprop:Generator_ChildPropName="Getxref_IDXRefDataRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>